﻿CREATE TABLE [dbo].[DBOst] (
    [ID]           UNIQUEIDENTIFIER DEFAULT (newid()) NOT NULL,
    [OstDate]      DATETIME         NOT NULL,
    [OstEvent]     VARCHAR (255)    NOT NULL,
    [OstValue]     FLOAT            NOT NULL,
    [InstrumentID] UNIQUEIDENTIFIER NULL,
    PRIMARY KEY CLUSTERED ([ID] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF),
    FOREIGN KEY ([InstrumentID]) REFERENCES [dbo].[DBInstruments] ([ID]) ON DELETE CASCADE ON UPDATE NO ACTION
);

